Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
ItemLotID (PK) | An identifier for a LOT of specific ITEMs. | ID_ITM_LOT | Identity | integer | |
LotNumber | A number or code associated with an item lot. In some cases, the lot number will be populated with a date (common in grocery and deli). A lot number may be assigned by a manufaturer or retailer. Lot numbers may be quite long and are treated here as descriptions to accomodate any length of alphanumeric lot number. | DE_NMB_LT | DescriptionShort | varchar(255) | |
IssuedByPartyID (FK) | A unique, system assigned identity for the Party that issed this particular ItemLot. | ID_PRTY_ISS | Identity | integer | Party(PA_PRTY) |